CREATE TABLE [dbo].[Friends]
(
[UserID] [int] NOT NULL IDENTITY(1, 1),
[NAME] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Email] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL,
[Phone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL,
[Mobile] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL,
[QQ] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL,
[MSN] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL,
[Birthday] [date] NULL,
[Remark] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL,
[IntroductionPicture] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL,
[IntroductionVideo] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL,
[GroupID] [int] NULL,
[PictureID] [int] NULL,
[VideoID] [int] NULL,
[Mobile2] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
ALTER TABLE [dbo].[Friends] ADD 
CONSTRAINT [PK__Friends__1788CCAC15502E78] PRIMARY KEY CLUSTERED  ([UserID]) ON [PRIMARY]
ALTER TABLE [dbo].[Friends] ADD
CONSTRAINT [FK__Friends__GroupID__173876EA] FOREIGN KEY ([GroupID]) REFERENCES [dbo].[Groups] ([GroupID])
ALTER TABLE [dbo].[Friends] ADD
CONSTRAINT [FK__Friends__Picture__182C9B23] FOREIGN KEY ([PictureID]) REFERENCES [dbo].[Pictures] ([PictureID])
ALTER TABLE [dbo].[Friends] ADD
CONSTRAINT [FK__Friends__VideoID__1920BF5C] FOREIGN KEY ([VideoID]) REFERENCES [dbo].[Videos] ([VideoID])



GO
